EXCEL查找,我想指定行的最大值,再找出这个最大值所在列的最大值所对应...答:第一个公式:=OFFSET(A3, MATCH(MAX(OFFSET(A3:A7, 0,MATCH(MAX(B1:D1), B1:D1, 0))), OFFSET(A3:A7, 0,MATCH(MAX(B1:D1), B1:D1, 0)))-1, 0)第二个公式:=OFFSET(A3, MATCH(LARGE(OFFSET(A3:A7, 0,MATCH(MAX(B1:D1), B1:D1, 0)),2), OFFSET(A3:A7, 0,MATCH...
excel2003,多条件求最大值显示对应的项答:假设表一为Sheet1,在表二B1输入公式:=IF(COUNTIF(Sheet1!B$1:B$100,A1),IF(MAX(IF(Sheet1!B$1:B$100=A1,Sheet1!C$1:C$100))<0,"",INDEX(Sheet1!A:A,RIGHT(MAX(IF(Sheet1!B$1:B$100=A1,Sheet1!C$1:C$100*10^8+ROW(A$1:A$100))),4))),"")数组公式,按Ctrl+...